---Update Branch_Information Set BR_Code='EN'
delete from AccessRights_Employees where User_Code<>'0001'
Update User_Logins Set Br_Code=(Select Br_Code from Branch_Information)
Update Branch_Information set LogOutAfterTransaction=0
Update Branch_Information set HasSwipeFeature=0
delete from syskeys
----if user wants to logout after everytransaction---
------------------------------------------------------------------------------------------------------
--Update Branch_Information set LogOutAfterTransaction=1
------------------------------------------------------------------------------------------------------
----if swipe feature is available
------------------------------------------------------------------------------------------------------
--Update Branch_Information set HasSwipeFeature=1
---------------------------------------------------------------------------------------------------------

Update Branch_Information set AppType='Clothing'
Update AccessRightsScreen set DisplayonMenu=0,DisplayonSizes=0 where AccessScreen in ('Products','FamilyGrouping')
Update AccessRightsScreen set DisplayonMenu=1,DisplayonSizes=1 where AccessScreen in ('Sizes List','Colors List','Multi Products')


Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0,DisplayonSizes=0 where AccessScreen in ('Magazine Types','Customer Magazines Link','Customer Magazines Delivery','Rooms','Services','Services and Rooms Linking','Customer Compliments Letter','Customer Medical History List','Customer Compliments','Customer Recurring Deposits List','Shifts List','Shifts Definition')

delete from General_ReasonList where TableLinkedTo in ('Products Sizes List','Products Colors List','Products Fittings List')
delete from BankDetails
DELETE FROM Appointments_Sub_Detail
DELETE FROM Appointments_Detail
DELETE FROM Appointments_Master

DELETE FROM Products_Colors_List where colorid NOT IN (select colorid from product_master where central_product_code  in ('9999','111111'))

delete from Sizes_Dtl WHERE SizeDtlId not in (select sizeid from product_master where central_product_code  in ('9999','111111'))

delete from Sizes_master  WHERE SizeSMasterID  not in (select sizescaleid from product_master where central_product_code  in ('9999','111111'))

delete from seasoncodes where SeasonID NOT IN (select SeasonID from product_master where central_product_code  in ('9999','111111'))

delete from creditnote
delete from creditnotelog
delete from CashDrawer_Dtl
delete from CashDrawer_Log
delete from CashDrawer_Mst
delete from Customer_Compliments_Letters

DELETE FROM Customer_MedicalHistory_Link
DELETE FROM CustomerComplimentList
DELETE FROM CustomerMedicalHistoryList

delete from Customers
delete from CustomerType_Product_Qty_PriceList

delete from Customer_Types

delete from EndDay_BalancingDtl
delete from EndDay_BalancingMst
delete from Grn_Dtl
delete from Grn_Mst
delete from HoldSales_Dtl
delete from HoldSales_Mst



DELETE FROM Log_Detail
DELETE FROM Log_MASTER

delete from Login_History

delete from Payment_Details
delete from PettyCash

DELETE FROM Locations_Master where ShopFloor<>'Y'
delete from Product_Qty_PriceList where centralproductcode not in ('9999','111111')
delete from Product_Supplier_BarCodes where centralproductcode not in ('9999','111111')
delete from Product_Master where central_product_code  not in ('9999','111111')

delete from subcategories where category_id2 NOT IN (select subcategoryid from product_master where central_product_code  in ('9999','111111'))
delete from Product_Categories_Level2 where category_id2 NOT IN (select category_id2 from product_master where central_product_code   in ('9999','111111'))
delete from Product_Categories_Level1 where Category_ID1 not in (Select Category_ID1 from Product_master where central_Product_Code in ('9999','0000','1111')) and category_id1 not in (select category_id1 from subcategories)

delete from Product_StockList

delete from ProductMovement_Dtl
delete from ProductMovement_Mst
delete from Promotions_Detail
delete from Promotions_Master
delete from Purchase_Order_Details
delete from Purchase_Orders
DELETE FROM Purchase_Payment_Details
DELETE FROM Purchase_Inv_Entry_Detail
DELETE FROM Purchase_Inv_Entry_MASTER


DELETE FROM Purchase_Payment_mASTER

DELETE FROM Sales_Payment_Details
DELETE FROM Sales_Payment_MASTER

DELETE FROM Service_Rooms
DELETE FROM Service_Rooms_Linking
DELETE FROM Services_Users_Linking

DELETE FROM Services_MixedServices
DELETE FROM Services_Pricing
DELETE FROM Services_Master

delete from Refund_Detail
delete from Refund_Mst
delete from Repacking_Detail
delete from Repacking_Master

delete from Sales_Dtl
delete from Sales_Mst
delete from Stock_Transactions
delete from StockAdjustment_Dtl
delete from StockAdjustmentMaster

delete from Supplier_Details where Supplier_Code not in (select supplier_code from product_supplier_barcodes where centralproductcode in ('9999','111111'))
--delete from TillSettings
DELETE FROM User_ClockIn_ClockOut

DELETE FROM User_Commissions_Dtl_Overall
DELETE FROM User_Commissions_Detail
DELETE FROM User_Salary_Log
DELETE FROM User_Commissions_mASTER
DELETE FROM User_Logins  where Usr_Code<>'0001'
--delete from Unit_Of_Measure
--delete from  Vat_Master

delete from StockIn_Master
delete from StockIn_Dtl
-----IGNORE IF U GET ERROR FROM HERE
delete from Branches_List
delete from BranchesStocks 

delete from product_qty_pricelist_branch
delete from BranchesStocks

delete from Branch_Stock_Transactions where br_code not in (select branchcode from branches_list)
go
delete from SalesByBranches
go
delete from Reorder_Products
go
delete from DeletedLines
go
delete from StockValuation
go
delete from BranchesStocks_ReadOnly
go
delete from sysmodules1
go
delete from CustomerDeliveryAddresses
update branch_information set ishotkeys=0,ZeroRatedVAT=0
Update dbo.General_ReasonList set Reason='Yes1' where TableLinkedto='HasDeliveryModule'
Update dbo.General_ReasonList set Reason='Yes1' where TableLinkedto='HasMultipleDeliveryAddresses'